create external table jms_dm.dm_warehousing_weight_type_sum_dt 
(
    network_code string COMMENT '网点CODE' ,
    network_name string COMMENT '网点名称' ,
    agent_code string COMMENT '代理区CODE' ,
    agent_name string COMMENT '代理区名称' ,
    city_id string COMMENT '城市ID' ,
    city_name string COMMENT '城市名称' ,
    province_id string COMMENT '省ID' ,
    province_name string COMMENT '省' ,
    zone_id string COMMENT '代理区ID' ,
    zone_code string COMMENT '片区区CODE' ,
    zone_name string COMMENT '片区区名称' ,
    zone_staff_code string COMMENT '片区负责人CODE' ,
    zone_staff_name string COMMENT '片区负责人名称' ,
    area_code string COMMENT '网管片区CODE' ,
    area_name string COMMENT '网管片区名称' ,
    area_staff_code string COMMENT '网管片区负责人CODE' ,
    area_staff_name string COMMENT '网管片区负责人名称'  ,
    weight_cnt          bigint COMMENT '称重票数' ,
    manual_weight_cnt   bigint COMMENT '手工称重票数' ,
    month_acc_weight_cnt          bigint COMMENT '月累计称重票数' ,
    month_acc_manual_weight_cnt   bigint COMMENT '月累计手工称重票数',
    month_acc_over_rate_cnt       bigint COMMENT '月累计手工称重超50%次数'
)
comment '锁秤稽查汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_warehousing_weight_type_sum_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
